SAMSTAR: An Automatic Tool for Generating Star Schemas from an Entity-Relationship Diagram
نویسندگان
چکیده
منابع مشابه
SAMSTARplus: An Automatic Tool for Generating Multi- Dimensional Schemas from an Entity-Relationship Diagram
This paper presents a tool that automatically generates multidimensional schemas for data warehouses from OLTP entity-relationship diagrams (ERDs). Based on user’s input parameters, it generates star schemas, snowflake schemas, or a fact constellation schema by taking advantage of only structural information of input ERDs. Hence, SAMSTARplus can help users reduce efforts for designing data ware...
متن کاملDesigning of Star Schemas from XML Document
A Star Schema is representation of a data warehouse which is used in strategic decision making and analysis. In this paper we present a method to convert an XML document into a ER diagram and that ER Diagram is converted into a star schema
متن کاملAn Automatic Method for the Design of Multidimensional Schemas from Object Oriented Databases
A data warehouse (DW) is a large data repository system designed for decision-making purposes. Its design relies on a speci ̄c model called multidimensional. This multidimensional model supports analyses of huge volumes of data that trace the enterprise's activities over time. Several design methods were proposed to build multidimensional schemas from either the relational data model or the enti...
متن کاملAn Executable Meta Model for Re-Engineering of Database Schemas
A logical database schema, e.g. a relational one, is an implementation of a speci cation, e.g. an entity-relationship diagram. Upcoming new data models and the necessity of seamless integration of databases into application programs require a cost-e ective method for mapping from one data model into the other. We present an approach where the mapping relationship is divided into three parts. Th...
متن کاملERDraw: An XML-based ER-diagram Drawing and Translation Tool
The Entity-Relationship (ER) model is one of the most popular methodologies for designing relational databases. Several commercial products have been developed to support drawing ER-diagrams in a graphical fashion. Their architectures and implementation details, however, are not available in public. Inspired by these products and recent developments in XML technology and semantic drawing framew...
متن کامل